Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	1080
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	126.7 KiB
Average record size in memory	120.1 B

Variable types

Numeric	15

Warnings

`gross-margin` is highly correlated with `pre-tax-profit-margin`	High correlation
`operating-margin` is highly correlated with `ebit-margin` and 4 other fields	High correlation
`ebit-margin` is highly correlated with `operating-margin` and 4 other fields	High correlation
`pre-tax-profit-margin` is highly correlated with `gross-margin` and 5 other fields	High correlation
`net-profit-margin` is highly correlated with `operating-margin` and 4 other fields	High correlation
`asset-turnover` is highly correlated with `receiveable-turnover`	High correlation
`receiveable-turnover` is highly correlated with `asset-turnover`	High correlation
`days-sales-in-receivables` is highly correlated with `book-value-per-share`	High correlation
`roa` is highly correlated with `operating-margin` and 4 other fields	High correlation
`roi` is highly correlated with `operating-margin` and 4 other fields	High correlation
`book-value-per-share` is highly correlated with `days-sales-in-receivables`	High correlation
`gross-margin` is highly correlated with `operating-margin` and 3 other fields	High correlation
`operating-margin` is highly correlated with `gross-margin` and 5 other fields	High correlation
`ebit-margin` is highly correlated with `gross-margin` and 5 other fields	High correlation
`pre-tax-profit-margin` is highly correlated with `gross-margin` and 6 other fields	High correlation
`net-profit-margin` is highly correlated with `gross-margin` and 5 other fields	High correlation
`asset-turnover` is highly correlated with `operating-margin` and 2 other fields	High correlation
`receiveable-turnover` is highly correlated with `days-sales-in-receivables`	High correlation
`days-sales-in-receivables` is highly correlated with `receiveable-turnover`	High correlation
`roe` is highly correlated with `roa` and 1 other fields	High correlation
`roa` is highly correlated with `operating-margin` and 5 other fields	High correlation
`roi` is highly correlated with `pre-tax-profit-margin` and 3 other fields	High correlation
`gross-margin` is highly correlated with `operating-margin` and 1 other fields	High correlation
`operating-margin` is highly correlated with `gross-margin` and 3 other fields	High correlation
`ebit-margin` is highly correlated with `operating-margin` and 2 other fields	High correlation
`pre-tax-profit-margin` is highly correlated with `gross-margin` and 3 other fields	High correlation
`net-profit-margin` is highly correlated with `operating-margin` and 3 other fields	High correlation
`receiveable-turnover` is highly correlated with `days-sales-in-receivables`	High correlation
`days-sales-in-receivables` is highly correlated with `receiveable-turnover`	High correlation
`roe` is highly correlated with `roa` and 1 other fields	High correlation
`roa` is highly correlated with `net-profit-margin` and 2 other fields	High correlation
`roi` is highly correlated with `roe` and 1 other fields	High correlation
`pre-tax-profit-margin` is highly correlated with `ebit-margin` and 5 other fields	High correlation
`ebit-margin` is highly correlated with `pre-tax-profit-margin` and 5 other fields	High correlation
`receiveable-turnover` is highly correlated with `gross-margin` and 1 other fields	High correlation
`roa` is highly correlated with `pre-tax-profit-margin` and 5 other fields	High correlation
`gross-margin` is highly correlated with `pre-tax-profit-margin` and 8 other fields	High correlation
`operating-margin` is highly correlated with `pre-tax-profit-margin` and 5 other fields	High correlation
`roe` is highly correlated with `roa` and 2 other fields	High correlation
`asset-turnover` is highly correlated with `receiveable-turnover` and 2 other fields	High correlation
`roi` is highly correlated with `pre-tax-profit-margin` and 6 other fields	High correlation
`days-sales-in-receivables` is highly correlated with `gross-margin` and 1 other fields	High correlation
`book-value-per-share` is highly correlated with `gross-margin` and 2 other fields	High correlation
`net-profit-margin` is highly correlated with `pre-tax-profit-margin` and 6 other fields	High correlation
`return-on-tangible-equity` is highly skewed (γ1 = 27.09442111)	Skewed
`sigma` has unique values	Unique

Reproduction

Analysis started	2021-05-26 18:17:48.972080
Analysis finished	2021-05-26 18:18:37.614275
Duration	48.64 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

current-ratio
Real number (ℝ_≥0)

Distinct	1056
Distinct (%)	97.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.836772593

Minimum	0.6058
Maximum	10.2911
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.6 KiB

Quantile statistics

Minimum	0.6058
5-th percentile	0.78648
Q1	1.072825
median	1.6114
Q3	2.165425
95-th percentile	3.582115
Maximum	10.2911
Range	9.6853
Interquartile range (IQR)	1.0926

Descriptive statistics

Standard deviation	1.163278872
Coefficient of variation (CV)	0.6333276511
Kurtosis	11.97975226
Mean	1.836772593
Median Absolute Deviation (MAD)	0.54705
Skewness	2.841235716
Sum	1983.7144
Variance	1.353217733
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.1184	3	0.3%
1.0743	2	0.2%
1.8357	2	0.2%
1.0062	2	0.2%
1.1743	2	0.2%
0.7598	2	0.2%
1.1089	2	0.2%
0.9661	2	0.2%
1.5632	2	0.2%
1.2198	2	0.2%
Other values (1046)	1059	98.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.6058	1	0.1%
0.6271	1	0.1%
0.6311	1	0.1%
0.6378	1	0.1%
0.674	1	0.1%
0.676	1	0.1%
0.6793	1	0.1%
0.68	1	0.1%
0.6919	1	0.1%
0.6926	1	0.1%

Value	Count	Frequency (%)
10.2911	1	0.1%
8.9848	1	0.1%
8.6492	1	0.1%
8.5425	1	0.1%
8.4203	1	0.1%
8.2564	1	0.1%
8.2561	1	0.1%
8.0269	1	0.1%
7.9436	1	0.1%
7.8198	1	0.1%

gross-margin
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	997
Distinct (%)	92.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	53.10515

Minimum	-17.4856
Maximum	129.3317
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	0.1%
Memory size	8.6 KiB

Quantile statistics

Minimum	-17.4856
5-th percentile	12.97307
Q1	31.8493
median	50.35775
Q3	76.021275
95-th percentile	100
Maximum	129.3317
Range	146.8173
Interquartile range (IQR)	44.171975

Descriptive statistics

Standard deviation	26.13756085
Coefficient of variation (CV)	0.492185049
Kurtosis	-0.8539319794
Mean	53.10515
Median Absolute Deviation (MAD)	19.8873
Skewness	0.2109783888
Sum	57353.562
Variance	683.1720874
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	82	7.6%
61.2909	2	0.2%
58.3093	2	0.2%
13.1787	1	0.1%
12.4575	1	0.1%
76.2599	1	0.1%
59.6443	1	0.1%
8.9347	1	0.1%
77.2587	1	0.1%
12.9247	1	0.1%
Other values (987)	987	91.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-17.4856	1	0.1%
1.7035	1	0.1%
4.5142	1	0.1%
6.399	1	0.1%
7.7876	1	0.1%
7.8489	1	0.1%
8.2185	1	0.1%
8.2238	1	0.1%
8.4186	1	0.1%
8.5938	1	0.1%

Value	Count	Frequency (%)
129.3317	1	0.1%
124.4902	1	0.1%
115.8079	1	0.1%
100	82	7.6%
94.44	1	0.1%
94.3009	1	0.1%
94.2748	1	0.1%
94.045	1	0.1%
93.9908	1	0.1%
93.6214	1	0.1%

operating-margin
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1077
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.42385861

Minimum	-398.3604
Maximum	69.4912
Zeros	0
Zeros (%)	0.0%
Negative	63
Negative (%)	5.8%
Memory size	8.6 KiB

Quantile statistics

Minimum	-398.3604
5-th percentile	-1.052825
Q1	8.4466
median	18.36625
Q3	29.366425
95-th percentile	55.085415
Maximum	69.4912
Range	467.8516
Interquartile range (IQR)	20.919825

Descriptive statistics

Standard deviation	25.8700549
Coefficient of variation (CV)	1.404160521
Kurtosis	93.44618205
Mean	18.42385861
Median Absolute Deviation (MAD)	10.4468
Skewness	-6.940098645
Sum	19897.7673
Variance	669.2597407
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.5345	2	0.2%
32.3864	2	0.2%
18.774	2	0.2%
15.1365	1	0.1%
19.6149	1	0.1%
33.953	1	0.1%
3.8675	1	0.1%
12.7404	1	0.1%
21.4911	1	0.1%
12.9076	1	0.1%
Other values (1067)	1067	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-398.3604	1	0.1%
-294.2387	1	0.1%
-216.4698	1	0.1%
-205.5263	1	0.1%
-111.8111	1	0.1%
-101.6374	1	0.1%
-100.9764	1	0.1%
-55.8318	1	0.1%
-36.5931	1	0.1%
-36.5368	1	0.1%

Value	Count	Frequency (%)
69.4912	1	0.1%
68.4286	1	0.1%
67.5928	1	0.1%
67.5082	1	0.1%
67.209	1	0.1%
67.1263	1	0.1%
67.0311	1	0.1%
66.9178	1	0.1%
66.9111	1	0.1%
66.3363	1	0.1%

ebit-margin
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1077
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.52549602

Minimum	-398.3604
Maximum	69.4912
Zeros	0
Zeros (%)	0.0%
Negative	63
Negative (%)	5.8%
Memory size	8.6 KiB

Quantile statistics

Minimum	-398.3604
5-th percentile	-1.052825
Q1	8.702375
median	18.3853
Q3	29.366425
95-th percentile	55.085415
Maximum	69.4912
Range	467.8516
Interquartile range (IQR)	20.66405

Descriptive statistics

Standard deviation	25.84626911
Coefficient of variation (CV)	1.395172852
Kurtosis	93.91136154
Mean	18.52549602
Median Absolute Deviation (MAD)	10.21585
Skewness	-6.970323235
Sum	20007.5357
Variance	668.0296271
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.774	2	0.2%
32.3864	2	0.2%
13.5345	2	0.2%
15.1365	1	0.1%
13.6739	1	0.1%
19.6149	1	0.1%
33.953	1	0.1%
3.8675	1	0.1%
12.7404	1	0.1%
21.4911	1	0.1%
Other values (1067)	1067	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-398.3604	1	0.1%
-294.2387	1	0.1%
-216.4698	1	0.1%
-205.5263	1	0.1%
-111.8111	1	0.1%
-101.6374	1	0.1%
-100.9764	1	0.1%
-55.8318	1	0.1%
-36.5931	1	0.1%
-36.5368	1	0.1%

Value	Count	Frequency (%)
69.4912	1	0.1%
68.4286	1	0.1%
67.5928	1	0.1%
67.5082	1	0.1%
67.209	1	0.1%
67.1263	1	0.1%
67.0311	1	0.1%
66.9178	1	0.1%
66.9111	1	0.1%
66.3363	1	0.1%

pre-tax-profit-margin
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1078
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.42620454

Minimum	-395.8054
Maximum	74.0253
Zeros	0
Zeros (%)	0.0%
Negative	71
Negative (%)	6.6%
Memory size	8.6 KiB

Quantile statistics

Minimum	-395.8054
5-th percentile	-5.84123
Q1	6.979825
median	16.74215
Q3	28.793325
95-th percentile	54.090035
Maximum	74.0253
Range	469.8307
Interquartile range (IQR)	21.8135

Descriptive statistics

Standard deviation	26.12481586
Coefficient of variation (CV)	1.499168439
Kurtosis	88.73654305
Mean	17.42620454
Median Absolute Deviation (MAD)	10.75155
Skewness	-6.711399514
Sum	18820.3009
Variance	682.5060037
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25.3371	2	0.2%
3.095	2	0.2%
5.4438	1	0.1%
-13.7932	1	0.1%
15.0104	1	0.1%
31.9853	1	0.1%
12.6766	1	0.1%
19.4197	1	0.1%
37.1077	1	0.1%
16.6276	1	0.1%
Other values (1068)	1068	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-395.8054	1	0.1%
-297.7227	1	0.1%
-220.9165	1	0.1%
-206.6692	1	0.1%
-112.7025	1	0.1%
-101.6374	1	0.1%
-101.0194	1	0.1%
-54.1663	1	0.1%
-40.6061	1	0.1%
-39.2429	1	0.1%

Value	Count	Frequency (%)
74.0253	1	0.1%
67.3194	1	0.1%
66.9405	1	0.1%
66.9276	1	0.1%
66.8835	1	0.1%
66.7788	1	0.1%
66.6187	1	0.1%
66.4513	1	0.1%
66.1986	1	0.1%
66.0222	1	0.1%

net-profit-margin
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1079
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.69518537

Minimum	-396.2143
Maximum	65.7126
Zeros	0
Zeros (%)	0.0%
Negative	83
Negative (%)	7.7%
Memory size	8.6 KiB

Quantile statistics

Minimum	-396.2143
5-th percentile	-7.539355
Q1	4.88635
median	12.18675
Q3	21.704725
95-th percentile	40.403375
Maximum	65.7126
Range	461.9269
Interquartile range (IQR)	16.818375

Descriptive statistics

Standard deviation	24.08975056
Coefficient of variation (CV)	1.897550123
Kurtosis	116.8255271
Mean	12.69518537
Median Absolute Deviation (MAD)	8.3527
Skewness	-8.294401742
Sum	13710.8002
Variance	580.3160821
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.6565	2	0.2%
49.0593	1	0.1%
19.8098	1	0.1%
38.6166	1	0.1%
0.2673	1	0.1%
2.2992	1	0.1%
40.1889	1	0.1%
3.7375	1	0.1%
24.995	1	0.1%
7.5177	1	0.1%
Other values (1069)	1069	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-396.2143	1	0.1%
-297.9183	1	0.1%
-221.148	1	0.1%
-206.9562	1	0.1%
-112.8533	1	0.1%
-101.2584	1	0.1%
-73.8454	1	0.1%
-71.6959	1	0.1%
-41.8251	1	0.1%
-40.9524	1	0.1%

Value	Count	Frequency (%)
65.7126	1	0.1%
60.8568	1	0.1%
54.9816	1	0.1%
54.9675	1	0.1%
54.9014	1	0.1%
54.446	1	0.1%
54.1864	1	0.1%
54.0683	1	0.1%
54.0469	1	0.1%
53.0993	1	0.1%

asset-turnover
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	934
Distinct (%)	86.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2431631481

Minimum	0.0038
Maximum	1.1871
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.6 KiB

Quantile statistics

Minimum	0.0038
5-th percentile	0.067175
Q1	0.122775
median	0.17565
Q3	0.33245
95-th percentile	0.610765
Maximum	1.1871
Range	1.1833
Interquartile range (IQR)	0.209675

Descriptive statistics

Standard deviation	0.1865749854
Coefficient of variation (CV)	0.7672831463
Kurtosis	4.116126573
Mean	0.2431631481
Median Absolute Deviation (MAD)	0.0822
Skewness	1.795366983
Sum	262.6162
Variance	0.03481022517
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1133	5	0.5%
0.1476	4	0.4%
0.1227	4	0.4%
0.009	3	0.3%
0.1262	3	0.3%
0.1356	3	0.3%
0.07	3	0.3%
0.0683	3	0.3%
0.1583	3	0.3%
0.1267	3	0.3%
Other values (924)	1046	96.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0038	1	0.1%
0.0066	1	0.1%
0.007	1	0.1%
0.0072	1	0.1%
0.0073	1	0.1%
0.0078	2	0.2%
0.008	1	0.1%
0.0083	1	0.1%
0.0084	1	0.1%
0.0087	2	0.2%

Value	Count	Frequency (%)
1.1871	1	0.1%
1.1638	1	0.1%
1.1024	1	0.1%
1.0877	1	0.1%
1.0836	1	0.1%
1.0757	1	0.1%
1.0728	1	0.1%
1.053	1	0.1%
1.0462	1	0.1%
0.9609	1	0.1%

receiveable-turnover
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1067
Distinct (%)	98.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.223371296

Minimum	0.0406
Maximum	34.4406
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.6 KiB

Quantile statistics

Minimum	0.0406
5-th percentile	1.148975
Q1	1.797225
median	2.3834
Q3	3.571275
95-th percentile	20.44938
Maximum	34.4406
Range	34.4
Interquartile range (IQR)	1.77405

Descriptive statistics

Standard deviation	5.521925982
Coefficient of variation (CV)	1.307468748
Kurtosis	8.425948528
Mean	4.223371296
Median Absolute Deviation (MAD)	0.71355
Skewness	2.994576843
Sum	4561.241
Variance	30.49166656
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1011	2	0.2%
2.4179	2	0.2%
2.2253	2	0.2%
2.6325	2	0.2%
2.3086	2	0.2%
2.2324	2	0.2%
1.8137	2	0.2%
0.0812	2	0.2%
2.4147	2	0.2%
2.3578	2	0.2%
Other values (1057)	1060	98.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0406	1	0.1%
0.0671	1	0.1%
0.0688	1	0.1%
0.0693	1	0.1%
0.0723	1	0.1%
0.0763	1	0.1%
0.0765	1	0.1%
0.0773	1	0.1%
0.0812	2	0.2%
0.0814	1	0.1%

Value	Count	Frequency (%)
34.4406	1	0.1%
31.4016	1	0.1%
30.9434	1	0.1%
30.9433	1	0.1%
29.5391	1	0.1%
29.2304	1	0.1%
29.2013	1	0.1%
29.2	1	0.1%
27.05	1	0.1%
26.9501	1	0.1%

days-sales-in-receivables
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1077
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	71.70540713

Minimum	2.6132
Maximum	2216.78
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.6 KiB

Quantile statistics

Minimum	2.6132
5-th percentile	4.4011
Q1	25.20105
median	37.761
Q3	50.07805
95-th percentile	78.33134
Maximum	2216.78
Range	2214.1668
Interquartile range (IQR)	24.877

Descriptive statistics

Standard deviation	187.7470797
Coefficient of variation (CV)	2.618311327
Kurtosis	35.34840922
Mean	71.70540713
Median Absolute Deviation (MAD)	12.48745
Skewness	5.628976652
Sum	77441.8397
Variance	35248.96592
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.9085	2	0.2%
4.6066	2	0.2%
38.9845	2	0.2%
58.6786	1	0.1%
47.3885	1	0.1%
29.2056	1	0.1%
27.5266	1	0.1%
22.3087	1	0.1%
30.4478	1	0.1%
55.2999	1	0.1%
Other values (1067)	1067	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.6132	1	0.1%
2.8661	1	0.1%
2.9085	2	0.2%
3.0468	1	0.1%
3.079	1	0.1%
3.0821	1	0.1%
3.0822	1	0.1%
3.3272	1	0.1%
3.3395	1	0.1%
3.3509	1	0.1%

Value	Count	Frequency (%)
2216.78	1	0.1%
1341.426	1	0.1%
1308.361	1	0.1%
1298.671	1	0.1%
1244.816	1	0.1%
1179.086	1	0.1%
1176.105	1	0.1%
1163.807	1	0.1%
1108.347	1	0.1%
1107.927	1	0.1%

roe
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1077
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.339295833

Minimum	-1058.823
Maximum	1458.974
Zeros	0
Zeros (%)	0.0%
Negative	106
Negative (%)	9.8%
Memory size	8.6 KiB

Quantile statistics

Minimum	-1058.823
5-th percentile	-11.92594
Q1	3.294675
median	5.85785
Q3	9.922975
95-th percentile	35.17226
Maximum	1458.974
Range	2517.797
Interquartile range (IQR)	6.6283

Descriptive statistics

Standard deviation	70.23355324
Coefficient of variation (CV)	9.56952204
Kurtosis	267.00294
Mean	7.339295833
Median Absolute Deviation (MAD)	3.0203
Skewness	1.750469819
Sum	7926.4395
Variance	4932.752
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.856	2	0.2%
3.3404	2	0.2%
5.9155	2	0.2%
4.6868	1	0.1%
10.5001	1	0.1%
8.1565	1	0.1%
2.9022	1	0.1%
9.431	1	0.1%
25.6493	1	0.1%
11.1798	1	0.1%
Other values (1067)	1067	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1058.823	1	0.1%
-1042.342	1	0.1%
-500.299	1	0.1%
-194.6524	1	0.1%
-169.7387	1	0.1%
-105.4545	1	0.1%
-87.9182	1	0.1%
-78.5297	1	0.1%
-72.1195	1	0.1%
-69.7341	1	0.1%

Value	Count	Frequency (%)
1458.974	1	0.1%
397.5031	1	0.1%
250.3289	1	0.1%
242.7975	1	0.1%
208.2143	1	0.1%
170.7654	1	0.1%
147.006	1	0.1%
128.3688	1	0.1%
123.7752	1	0.1%
108.6342	1	0.1%

return-on-tangible-equity
Real number (ℝ)

SKEWED

Distinct	1079
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.61555926

Minimum	-4503.571
Maximum	19186.67
Zeros	0
Zeros (%)	0.0%
Negative	358
Negative (%)	33.1%
Memory size	8.6 KiB

Quantile statistics

Minimum	-4503.571
5-th percentile	-51.582105
Q1	-6.714125
median	6.1719
Q3	13.27035
95-th percentile	53.782125
Maximum	19186.67
Range	23690.241
Interquartile range (IQR)	19.984475

Descriptive statistics

Standard deviation	618.4816593
Coefficient of variation (CV)	39.60675689
Kurtosis	861.1433446
Mean	15.61555926
Median Absolute Deviation (MAD)	10.10745
Skewness	27.09442111
Sum	16864.804
Variance	382519.5629
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.3773	2	0.2%
-51.89	1	0.1%
177.7916	1	0.1%
-3.2866	1	0.1%
24.7869	1	0.1%
15.4112	1	0.1%
7.4005	1	0.1%
133.3748	1	0.1%
-2.9231	1	0.1%
11.8437	1	0.1%
Other values (1069)	1069	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4503.571	1	0.1%
-3572.881	1	0.1%
-1801.064	1	0.1%
-840.7895	1	0.1%
-793.3333	1	0.1%
-514.7059	1	0.1%
-422.9167	1	0.1%
-392.1844	1	0.1%
-272.2793	1	0.1%
-271.9895	1	0.1%

Value	Count	Frequency (%)
19186.67	1	0.1%
1243.269	1	0.1%
796.3158	1	0.1%
734.0502	1	0.1%
679.0816	1	0.1%
545.3782	1	0.1%
542.8571	1	0.1%
468.9349	1	0.1%
438.4134	1	0.1%
426.1262	1	0.1%

roa
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1074
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.289651389

Minimum	-13.6934
Maximum	19.8728
Zeros	0
Zeros (%)	0.0%
Negative	83
Negative (%)	7.7%
Memory size	8.6 KiB

Quantile statistics

Minimum	-13.6934
5-th percentile	-1.22071
Q1	1.204675
median	2.28155
Q3	3.61785
95-th percentile	5.80581
Maximum	19.8728
Range	33.5662
Interquartile range (IQR)	2.413175

Descriptive statistics

Standard deviation	2.586426598
Coefficient of variation (CV)	1.129615893
Kurtosis	9.838313678
Mean	2.289651389
Median Absolute Deviation (MAD)	1.2168
Skewness	-1.234660762
Sum	2472.8235
Variance	6.689602546
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.5165	2	0.2%
3.9088	2	0.2%
0.7797	2	0.2%
5.524	2	0.2%
2.5272	2	0.2%
1.4648	2	0.2%
5.3612	1	0.1%
2.9023	1	0.1%
1.5479	1	0.1%
1.6315	1	0.1%
Other values (1064)	1064	98.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-13.6934	1	0.1%
-13.5934	1	0.1%
-11.8284	1	0.1%
-11.825	1	0.1%
-11.8083	1	0.1%
-11.4219	1	0.1%
-11.2279	1	0.1%
-10.6984	1	0.1%
-9.6629	1	0.1%
-9.2935	1	0.1%

Value	Count	Frequency (%)
19.8728	1	0.1%
12.1506	1	0.1%
10.8552	1	0.1%
9.9546	1	0.1%
9.4202	1	0.1%
9.2654	1	0.1%
9.0064	1	0.1%
8.5468	1	0.1%
8.5249	1	0.1%
8.2811	1	0.1%

roi
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1076
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.869756481

Minimum	-28.2224
Maximum	28.8795
Zeros	0
Zeros (%)	0.0%
Negative	83
Negative (%)	7.7%
Memory size	8.6 KiB

Quantile statistics

Minimum	-28.2224
5-th percentile	-2.351885
Q1	2.0715
median	3.86525
Q3	5.9301
95-th percentile	10.50602
Maximum	28.8795
Range	57.1019
Interquartile range (IQR)	3.8586

Descriptive statistics

Standard deviation	4.584574927
Coefficient of variation (CV)	1.184719232
Kurtosis	9.26523692
Mean	3.869756481
Median Absolute Deviation (MAD)	1.9235
Skewness	-1.271508624
Sum	4179.337
Variance	21.01832726
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.3184	2	0.2%
1.7282	2	0.2%
2.8265	2	0.2%
2.6121	2	0.2%
3.5385	1	0.1%
0.3275	1	0.1%
8.6589	1	0.1%
8.0251	1	0.1%
4.6559	1	0.1%
4.8553	1	0.1%
Other values (1066)	1066	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-28.2224	1	0.1%
-22.8594	1	0.1%
-22.804	1	0.1%
-21.3103	1	0.1%
-20.1289	1	0.1%
-18.3689	1	0.1%
-18.0498	1	0.1%
-16.7735	1	0.1%
-16.4555	1	0.1%
-16.3816	1	0.1%

Value	Count	Frequency (%)
28.8795	1	0.1%
22.7344	1	0.1%
21.7919	1	0.1%
20.0757	1	0.1%
17.3741	1	0.1%
16.9442	1	0.1%
16.5854	1	0.1%
16.4815	1	0.1%
16.2948	1	0.1%
16.252	1	0.1%

book-value-per-share
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1079
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.18046972

Minimum	-12.7175
Maximum	287.2318
Zeros	0
Zeros (%)	0.0%
Negative	37
Negative (%)	3.4%
Memory size	8.6 KiB

Quantile statistics

Minimum	-12.7175
5-th percentile	0.599345
Q1	6.086925
median	11.538
Q3	22.0596
95-th percentile	116.75221
Maximum	287.2318
Range	299.9493
Interquartile range (IQR)	15.972675

Descriptive statistics

Standard deviation	43.4579332
Coefficient of variation (CV)	1.797232796
Kurtosis	13.93263525
Mean	24.18046972
Median Absolute Deviation (MAD)	6.49525
Skewness	3.655051625
Sum	26114.9073
Variance	1888.591958
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24.0535	2	0.2%
7.7356	1	0.1%
0.241	1	0.1%
12.4676	1	0.1%
9.2199	1	0.1%
4.6842	1	0.1%
3.3888	1	0.1%
2.7395	1	0.1%
1.682	1	0.1%
22.0295	1	0.1%
Other values (1069)	1069	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-12.7175	1	0.1%
-12.4995	1	0.1%
-11.4184	1	0.1%
-11.4165	1	0.1%
-11.3704	1	0.1%
-11.0013	1	0.1%
-9.6978	1	0.1%
-8.966	1	0.1%
-8.8113	1	0.1%
-8.5801	1	0.1%

Value	Count	Frequency (%)
287.2318	1	0.1%
278.8	1	0.1%
269.2758	1	0.1%
268.6553	1	0.1%
261.7617	1	0.1%
259.8728	1	0.1%
257.3698	1	0.1%
252.0996	1	0.1%
246.1284	1	0.1%
245.2399	1	0.1%

sigma
Real number (ℝ_≥0)

UNIQUE

Distinct	1080
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.01545417606

Minimum	0.00059529
Maximum	0.123591654
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.6 KiB

Quantile statistics

Minimum	0.00059529
5-th percentile	0.0041437389
Q1	0.0074460325
median	0.0121869245
Q3	0.01947309275
95-th percentile	0.03732603275
Maximum	0.123591654
Range	0.122996364
Interquartile range (IQR)	0.01202706025

Descriptive statistics

Standard deviation	0.01224277033
Coefficient of variation (CV)	0.7921981917
Kurtosis	14.81865922
Mean	0.01545417606
Median Absolute Deviation (MAD)	0.0055702155
Skewness	2.861845738
Sum	16.69051015
Variance	0.0001498854254
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.004802829	1	0.1%
0.004773811	1	0.1%
0.017896178	1	0.1%
0.020984624	1	0.1%
0.012041931	1	0.1%
0.012245656	1	0.1%
0.008528817	1	0.1%
0.010467629	1	0.1%
0.009349914	1	0.1%
0.010103748	1	0.1%
Other values (1070)	1070	99.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.00059529	1	0.1%
0.001572467	1	0.1%
0.001620595	1	0.1%
0.001683512	1	0.1%
0.001785372	1	0.1%
0.00180568	1	0.1%
0.001866554	1	0.1%
0.001949867	1	0.1%
0.002029394	1	0.1%
0.002148074	1	0.1%

Value	Count	Frequency (%)
0.123591654	1	0.1%
0.117521755	1	0.1%
0.095849053	1	0.1%
0.091363569	1	0.1%
0.083293638	1	0.1%
0.070201455	1	0.1%
0.067956236	1	0.1%
0.064192331	1	0.1%
0.060272849	1	0.1%
0.058743578	1	0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	current-ratio	gross-margin	operating-margin	ebit-margin	pre-tax-profit-margin	net-profit-margin	asset-turnover	receiveable-turnover	days-sales-in-receivables	roe	return-on-tangible-equity	roa	roi	book-value-per-share	sigma
0	1.1417	42.5065	30.7008	30.7008	31.2679	26.3775	0.2657	2.7117	33.1894	34.1583	34.1583	7.0086	13.2887	4.1458	0.017064
1	1.1630	39.7778	30.0918	30.0918	30.1322	25.8034	0.3148	1.9010	47.3425	43.4208	43.4208	8.1216	17.3741	3.9365	0.016324
2	1.3636	38.1604	22.8369	22.8369	23.0316	19.5879	0.1998	1.7278	52.0889	19.3958	19.3958	3.9128	7.7272	3.8487	0.023187
3	1.4695	37.9995	21.9335	21.9335	22.0106	18.8540	0.1881	1.8608	48.3664	15.5682	15.5682	3.5460	6.7655	4.2182	0.033035
4	1.4960	38.3619	22.0414	22.0414	22.5250	19.2907	0.1820	1.9009	47.3467	14.3436	14.3436	3.5109	6.7154	4.5343	0.011731
5	1.5978	38.3548	27.8472	27.8472	28.2273	24.2172	0.2696	2.2986	39.1546	24.8361	24.8361	6.5281	12.1768	5.1044	0.033503
6	1.5401	37.9653	24.3988	24.3988	25.1827	21.3710	0.1892	1.3981	64.3716	15.1247	15.1247	4.0429	7.5076	5.0913	0.011626
7	1.5046	37.5904	21.4537	21.4537	22.1357	18.6660	0.1670	2.0325	44.2800	10.4130	10.4130	3.1169	5.5372	5.3215	0.027358
8	1.3154	37.6127	23.1233	23.1233	23.7749	19.9276	0.1696	2.2077	40.7657	10.9210	10.9210	3.3804	5.8966	5.7442	0.020733
9	1.3006	37.9919	27.6907	27.6907	28.3549	23.6805	0.2256	2.2798	39.4768	16.9350	16.9350	5.3422	9.4674	6.2313	0.015753

Last rows

	current-ratio	gross-margin	operating-margin	ebit-margin	pre-tax-profit-margin	net-profit-margin	asset-turnover	receiveable-turnover	days-sales-in-receivables	roe	return-on-tangible-equity	roa	roi	book-value-per-share	sigma
1070	1.6680	35.6605	6.5024	6.5024	3.4908	3.2854	0.3384	1.6735	53.7782	11.0599	-23.8806	1.1119	1.9370	0.6003	0.010815
1071	1.6940	39.5349	-2.4978	-2.4978	-6.1154	-6.3738	0.2979	1.7328	51.9380	-20.6128	26.3345	-1.8989	-3.0820	0.4986	0.014160
1072	1.7699	40.9007	-9.0074	-9.0074	-13.2353	-13.4191	0.2865	1.6868	53.3548	-35.1807	63.4783	-3.8451	-5.9495	0.5812	0.055561
1073	1.6213	15.4113	-36.5368	-36.5368	-40.6061	-40.9524	0.2888	1.8333	49.0909	-87.9182	426.1262	-11.8250	-18.3689	0.7546	0.018355
1074	1.8103	30.8905	-10.3231	-10.3231	-12.3720	-12.3720	0.2752	1.8580	48.4397	-15.8746	-46.7262	-3.4042	-5.1918	1.3890	0.025707
1075	1.3746	45.1522	5.4494	5.4494	2.1939	2.6185	0.2803	1.8992	47.3885	3.3124	8.0610	0.7340	1.3968	1.5799	0.013711
1076	1.3613	1.7035	-36.5931	-36.5931	-39.2429	-37.2240	0.3178	1.6476	54.6246	-56.0837	-151.2820	-11.8284	-22.8594	1.5029	0.025463
1077	1.8202	45.7126	4.1987	4.1987	-10.4672	-10.4672	0.3413	1.8400	48.9119	-10.8805	-13.7411	-3.4921	-5.5502	2.2779	0.017424
1078	1.8394	44.7337	8.1657	8.1657	5.4438	5.7396	0.3228	1.8612	48.3550	5.5619	6.8794	1.8526	2.9261	2.5022	0.031855
1079	2.6204	45.7433	6.6709	6.6709	4.0661	3.8755	0.3013	2.0738	43.3990	3.7172	4.6959	1.1677	1.5902	2.3748	0.049484

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows